-- @owner: wan005
-- @date: 2025/5/21
-- @testpoint: 【A兼容性--type功能增强】使用抽象数据类型--使用type构造函数.部分合理报错

--pre1:连接A库执行
@conn PrimaryDbAmode;

--step1:创建数据类型；expect:部分合理报错
create or replace type t1_027 as object(
atri_pid number,
atri_name varchar2(10),
atri_sex varchar2(10),
constructor function person_base(patri_pid number) return self as result);
 
create or replace type t1_027 as object(
atri_pid number,
atri_name varchar2(10),
atri_sex varchar2(10),
constructor function t1_027(patri_pid number) return self as result);

--step2:清理环境；expect:成功
drop type t1_027;